<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">
<html>
<head>
<title>Common SQL Statement Classes</title>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <meta name="generator" content="Doc-O-Matic" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <link rel="STYLESHEET" href="default.css" type="text/css" />

<script type="text/javascript" src="scripts.js"></script>
</head>
<body class="Element700" onload="onBodyLoadEx('frames.html', 'topic', 'Common_SQL_Statement_Classes.html');" onmousedown="onBodyMouseDown();">

<!-- Begin Popups -->

<!-- End Popups -->

<!-- Begin Page Header -->
<div class="Element710" id="areafixed">
<div class="Element94">
<em>You are here:</em> Symbol Reference &gt; <a href="!!CLASSES.html" target="topic">Classes</a> &gt; <a href="Common_SQL_Statement_Classes.html" target="topic">Common SQL Statement Classes</a></div>
<div class="Element92">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="50%">
<div class="Element2">
<a href="contents.html" target="tocidx"><img src="btn_globals_contents_midblue.gif" border="0" alt="Contents" title="Contents" onmouseover="switchImage(this, 'btn_globals_contents_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_contents_midblue.gif');"></a><a href="idx.html" target="tocidx"><img src="btn_globals_index_midblue.gif" border="0" alt="Index" title="Index" onmouseover="switchImage(this, 'btn_globals_index_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_index_midblue.gif');"></a><a href="index.html" target="topic"><img src="btn_globals_home_midblue.gif" border="0" alt="Home" title="Home" onmouseover="switchImage(this, 'btn_globals_home_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_home_midblue.gif');"></a></div>
</td><td width="50%">
<div class="Element90">
<a href="!!CLASSES.html" target="topic"><img src="btn_prev_midblue.gif" border="0" alt="Previous" title="Previous" onmouseover="switchImage(this, 'btn_prev_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_prev_midblue.gif');"></a><a href="!!CLASSES.html" target="topic"><img src="btn_up_midblue.gif" border="0" alt="Up" title="Up" onmouseover="switchImage(this, 'btn_up_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_up_midblue.gif');"></a><a href="TAlterSessionStatement.html" target="topic"><img src="btn_next_midblue.gif" border="0" alt="Next" title="Next" onmouseover="switchImage(this, 'btn_next_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_next_midblue.gif');"></a></div>
</td></tr></table><div class="Element5">
Common SQL Statement Classes</div>
</div>
</div>

<!-- End Page Header -->

<!-- Begin Client Area -->
<div class="Element720" id="areascroll">
<div class="Element721">

<!-- Begin Page Content -->
<div class="Element58">
<a name="Classes"></a><div class="Section1000030">
Classes</div>
<div class="Element10030">
<div class="Section30">
<div class="Element212">
<div class="TableDiv">
<table cellspacing="0" class="Table0">
<tr>
<td class="Element200" valign="top" width="35%">
<div class="Element201">
Class&nbsp;</div></td><td class="Element204" valign="top" width="65%">
<div class="Element205">
Description&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TAlterSessionStatement.html" target="topic">TAlterSessionStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Class used to represent alter session sql statement.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TCommitSqlStatement.html" target="topic">TCommitSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
Class used to represent commit sql statement.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TCommonTableExpression.html" target="topic">TCommonTableExpression</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Class represents Common Table Expression.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TCreateIndexSqlStatement.html" target="topic">TCreateIndexSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Class represents <a href="TCustomSqlStatement_Create@TDbVendor.html" target="topic">create</a> index statement.<br>You can obtain column information in <a href="TCustomSqlStatement_Fields.html" target="topic">Fields</a> property.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TCreateTableSqlStatement.html" target="topic">TCreateTableSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Class represents <a href="TCustomSqlStatement_Create@TDbVendor.html" target="topic">create</a> table statement.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TCreateViewSqlStatement.html" target="topic">TCreateViewSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Class represents <a href="TCustomSqlStatement_Create@TDbVendor.html" target="topic">create</a> view statement.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TCustomSqlStatement.html" target="topic">TCustomSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>This is the base class of all classes that represent a sql statement.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TDeleteSqlStatement.html" target="topic">TDeleteSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
Class represents delete statement.<br><br>How to find table(s) in delete statement class?<br><br>All tables can be found in <a href="TCustomSqlStatement_Tables.html" target="topic">Tables</a> property. But you can<br>fetch specific table from the following different properties.<br><br><a href="TCustomSqlStatement_Table.html" target="topic">Table</a>, <a href="TDeleteSqlStatement_DeletedTables.html" target="topic">DeletedTables</a>, <a href="TDeleteSqlStatement_JoinTables.html" target="topic">JoinTables</a><br><br>[MySQL]<br>Delete tablelist from tablelist<br>First tablelist is in <a href="TDeleteSqlStatement_DeletedTables.html" target="topic">DeletedTables</a>, and second tablelist is in <a href="TDeleteSqlStatement_JoinTables.html" target="topic">JoinTables</a><br><br>[Sql Server]<br>Delete table from tablelist<br>First table is in <a href="TCustomSqlStatement_Table.html" target="topic">Table</a> property, and tablelist is in <a href="TDeleteSqlStatement_JoinTables.html" target="topic">JoinTables</a>.<br><br>[Oracle,DB2]<br>Delete table<br>This table is in <a href="TCustomSqlStatement_Table.html" target="topic">Table</a> property.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TDropIndexSqlStatement.html" target="topic">TDropIndexSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
Class represents drop index statement.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TDropTableSqlStatement.html" target="topic">TDropTableSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Class represents drop table statement.<br><br><a href="TCustomSqlStatement_Table.html" target="topic">Table</a> information can be fetched from <a href="TCustomSqlStatement_Tables.html" target="topic">Tables</a>[0]&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TDropViewSqlStatement.html" target="topic">TDropViewSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Class represents drop view statement&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TInsertSqlStatement.html" target="topic">TInsertSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Class represents insert statement.<br><br>table name of insert statement can be found in <a href="TCustomSqlStatement_Table.html" target="topic">Table</a> property.<br><br>values can be found in <a href="TCustomSqlStatement_Fields.html" target="topic">Fields</a> property.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TMergeSqlStatement.html" target="topic">TMergeSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Represents merge statement.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TSelectSqlStatement.html" target="topic">TSelectSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
Represents select sql statement.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="TUpdateSqlStatement.html" target="topic">TUpdateSqlStatement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Class represents update statement.<br><br>If there is only one table in update clause, check this table in <a href="TCustomSqlStatement_Table.html" target="topic">Table</a> property.<br><br>If there is more than one table in update clause, check these tables in <a href="TUpdateSqlStatement_UpdateTables.html" target="topic">UpdateTables</a> properties.<br><br>If there is a from clause in update statement, check those<br>tables in from clause in <a href="TUpdateSqlStatement_JoinTables.html" target="topic">JoinTables</a> property.<br><br>Set clause information can be found in <a href="TCustomSqlStatement_Fields.html" target="topic">Fields</a> property.&nbsp;</div></td></tr></table></div></div>
</div>
</div>
<a name="Modules"></a><div class="Section1000030">
Modules</div>
<div class="Element10030">
<div class="Section30">
<div class="Element212">
<div class="TableDiv">
<table cellspacing="0" class="Table0">
<tr>
<td class="Element200" valign="top" width="35%">
<div class="Element201">
Module&nbsp;</div></td><td class="Element204" valign="top" width="65%">
<div class="Element205">
Description&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<a href="Raw_node_of_Common_SQL_Statement.html" target="topic">Raw node of Common SQL Statement</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
&nbsp;</div></td></tr></table></div></div>
</div>
</div>
</div>
<!-- End Page Content -->

<!-- Begin Page Footer -->
<div class="Element93">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="100%">
<div class="Element3">
Gudu software http://www.sqlparser.com</div>
</td></tr><tr><td width="100%">
<div class="Element97">
Send <a href="#" onclick="sendFeedback('info@sqlparser.com', 'Documentation Feedback', 'Project: General SQL Parser Help file%0ATopic ID: Common SQL Statement Classes%0ATitle: Common SQL Statement Classes');">comments</a> about this topic.</div>
</td></tr></table></div>

<!-- End Page Footer -->
</div>
</div>

<!-- End Client Area -->
</body></html>